﻿IF EXISTS (SELECT * FROM sysobjects WHERE type = 'P' AND name = 'usp_UPDMS_MNY_IN_OUT_MGT_Set_Living_Cost_For_Balance')
	BEGIN
		DROP Procedure usp_UPDMS_MNY_IN_OUT_MGT_Set_Living_Cost_For_Balance
	END
GO

SET ANSI_NULLS ON
SET QUOTED_IDENTIFIER ON
GO
/******************************************************************************
**	Name : usp_UPDMS_MNY_IN_OUT_MGT_Set_Living_Cost_For_Balance
**	Desc : 생활비 차감관리 - 생활비 차감처리
**	Test Exec Query : Exec usp_UPDMS_MNY_IN_OUT_MGT_Set_Living_Cost_For_Balance 997, '47000', '비고'
**	Called by : Mny_Dac_UPDMS_MNY_IN_OUT_MGT.cs
**	Program ID : Mny3012p
**	Auth : 송시명
**	Date : 2010-06-08
*******************************************************************************
**	Change History
*******************************************************************************
**	Date:		Author:		Description:
**	--------	--------	---------------------------------------
**	
*******************************************************************************/
CREATE PROC [dbo].[usp_UPDMS_MNY_IN_OUT_MGT_Set_Living_Cost_For_Balance]
@li_seq int,
@li_amount int,
@ls_remark nvarchar(2000),
@ls_user_id nvarchar(20)
AS
SET NOCOUNT OFF

UPDATE UPDMS_MNY_IN_OUT_MGT
   SET Amount = @li_amount,
       Remark = Remark + CHAR(13) + CHAR(10) + @ls_remark,
       Update_User = @ls_user_id,
       Update_Dt = GETDATE()
 WHERE Seq = @li_seq

GO